package com.cc.visitor.dao;

import com.cc.visitor.entity.TemplateMsgDetail;
import com.cc.visitor.entity.TemplateMsgMain;
import com.mybatisflex.core.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author chanchaw
 * @create 2024-12-02 19:28
 */
@Repository
public interface TemplateMsgDetailMapper extends BaseMapper<TemplateMsgDetail> {
    @Select("call usp_getTemplateMsgDetail8TemplateId(#{templateId})")
    List<TemplateMsgDetail> select8TemplateId(@Param("templateId") String templateId);
    @Select("select * from template_msg_detail where parent_id = #{parentId}")
    List<TemplateMsgDetail> select8ParentId(@Param("parentId") Integer parentId);
}
